Release 10.1A: OpenEdge Development:
Basic Database Tools

Dump as CREATE VIEW Statement option

Choose PRO/SQL Dump as CREATE VIEW Statement to generate an SQL DDL program that contains CREATE VIEW statements equivalent to those originally used to define the selected view.

Note: Views of non-OpenEdge databases are treated as tables. To display information for these views, use the table reports option. See the "Reports option" section for more information on generating a table report.

When you choose this option, the Data Dictionary alphabetically lists all the views defined for your database. Select the views for which you want make CREATE VIEW statements. A dialog box similar to the one shown in Figure 11–14 appears.

Figure 11–14: Dump CREATE VIEW dialog box

The Dump CREATE VIEW dialog box contains the following fields:

Output File

Specifies the filename to which you want to write the CREATE VIEW statements. The default filename is either the view or database name with a .p extension.

Statement Termination

Specifies the statement termination character. The options are a period (.) or a semi-colon (;). The default value is a period (.).

Which User

If all views are selected, specifies all users or the User ID of the single user for whom you want to dump the views. The default value is All Users.

After generating the file, the Data Dictionary prompts you to continue.